package com.azure.mapper.report;

import com.azure.entity.AUserMonthlyReport;
import com.azure.entity.AUserMonthlyReportExample;
import java.util.List;

import net.minidev.json.JSONObject;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface AUserMonthlyReportMapper {
    int countByExample(AUserMonthlyReportExample example);

    int deleteByExample(AUserMonthlyReportExample example);

    int deleteByPrimaryKey(Long id);

    int insert(AUserMonthlyReport record);

    int insertSelective(AUserMonthlyReport record);

    List<AUserMonthlyReport> selectByExample(AUserMonthlyReportExample example);

    AUserMonthlyReport selectByPrimaryKey(Long id);

    int updateByExampleSelective(@Param("record") AUserMonthlyReport record, @Param("example") AUserMonthlyReportExample example);

    int updateByExample(@Param("record") AUserMonthlyReport record, @Param("example") AUserMonthlyReportExample example);

    int updateByPrimaryKeySelective(AUserMonthlyReport record);

    int updateByPrimaryKey(AUserMonthlyReport record);

    @Select("select province,count from a_user_monthly_report where date = ${date} " )
    List<JSONObject> selectProvinceCount(@Param("date") String date);
}